The following tables are part of the iMIS database:
Duplicate_Group (stores information regarding actions to take for the group)
|
Column Name |
Data Type/Size |
Description |
|
SEQN |
Long |
Primary key |
|
DUP_MATCH_KEY |
varchar(255) |
Duplicate field values |
|
MERGE_NOTE |
varchar(255) |
Notes to be stored in merged Activity Records |
|
PREF_MAIL |
Integer |
Address for preferred mailing |
|
PREF_BILL |
Integer |
Address for preferred billing |
|
MERGE_IDS |
varchar(255) |
Comma delimited IDs to be merged |
|
DELETE_IDS |
varchar(255) |
Comma delimited IDs to be deleted |
|
KEEP_IDS |
varchar(255) |
Comma delimited IDs to keep unchanged |
|
ADDR_1_NUM |
Integer |
Main Address to be retained |
|
ADDR_2_NUM |
Integer |
Second Address to be retained |
|
ADDR_3_NUM |
Integer |
Third Address to be retained |
|
RETAIN_ID |
varchar(12) |
ID of the record to retain |
Duplicate (stores information regarding each duplicate ID)
|
Column Name |
Data Type/Size |
Description |
|
SEQN |
Numeric |
Related Key to Duplicate_Group |
|
ID |
varchar(12) |
Name ID |
|
FULL_NAME |
varchar(50) |
Name FULL_NAME |
|
ADDR_1 |
Integer |
Main Address of ID |
|
ADDR_2 |
Integer |
Second Address of ID |
|
ADDR_3 |
Integer |
Third Address of ID |